package org.jeecg.modules.ParameterModule.mapper;

import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import org.apache.ibatis.annotations.Param;
import org.jeecg.modules.ParameterModule.entity.CategoryMaterialInfo;
import org.jeecg.modules.ParameterModule.entity.MlccCategoryInfo;

import java.util.List;

public interface FormalPlateInfoMapper {
    //分页查询版号列表
    IPage<MlccCategoryInfo> query_CategoryPageList(@Param("page") Page<MlccCategoryInfo> page, @Param("queryName")String queryName, @Param("queryCode")String queryCode,@Param("pingleiName")String pingleiName);

    /**版号下的里布列表*/
    IPage<CategoryMaterialInfo> query_material_libuPageList(@Param("page") Page<CategoryMaterialInfo> page, @Param("category_id")String category_id,@Param("queryName")String queryName, @Param("queryCode")String queryCode);
    /**版号下的低领里列表*/
    IPage<CategoryMaterialInfo> query_material_dilingliPageList(@Param("page") Page<CategoryMaterialInfo> page,@Param("category_id")String category_id, @Param("queryName")String queryName, @Param("queryCode")String queryCode);
    /**版号下的纽扣列表*/
    IPage<CategoryMaterialInfo> query_material_buttonsPageList(@Param("page") Page<CategoryMaterialInfo> page,@Param("category_id")String category_id, @Param("queryName")String queryName, @Param("queryCode")String queryCode);

    /**查询所有的里布/底领尼/纽扣*/
    List<CategoryMaterialInfo> query_all_materialInfo(@Param("type")int type);
    /**新增里布*/
    int add_plate_libu(CategoryMaterialInfo testinfo);
    /**删除里布*/
    int delete_plate_libu(@Param("id")String id);
    /**新增底领尼*/
    int add_plate_dilingli(CategoryMaterialInfo testinfo);
    /**删除底领尼*/
    int delete_plate_dilingli(@Param("id")String id);
    /**新增纽扣*/
    int add_plate_buttons(CategoryMaterialInfo testinfo);
    /**删除纽扣*/
    int delete_plate_buttons(@Param("id")String id);

    /**查询所有的辅料*/
    List<CategoryMaterialInfo> query_AllfuliaoBypingleiId(@Param("plate_id")String plate_id);

    /**根据品类id修改加价项的版号*/
    int update_price_pinglei(@Param("pinglei_id")String pinglei_id,@Param("banhao_id")String banhao_id);

}
